package com.trkj.dao.lzs;
import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.trkj.pojo.Jobseekersregister;
import com.trkj.pojo.SocialSecurity;

public interface JobseekersregisterDAO extends JpaRepository<Jobseekersregister, Long>{
	/**
	 *
	 * @param p
	 * @return
	 */
	@Query("from Jobseekersregister d") 
	public List<Jobseekersregister> queryByPage(Pageable p);

	/**
	 * 模糊查询
	 * @param name
	 * @return
	 */
	/*@Query("from Jobseekersregister d where d.jsmdName like ?1") 
	public List<Jobseekersregister> queryByName(String name);*/
	@Query("select j from Jobseekersregister j inner join j.jobseekersmasterdates m") 
	public List<Jobseekersregister> findAllByMainDate();
	
	 @Query("from Jobseekersregister s where s.jsrName like ?1")
	    public  List<Jobseekersregister>jsrqueryByName(String text);	
}
